UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dKa3LW9MULRrTHzdT/XJ5/KykS02opc71kdiA5ThsGw='
WHERE
key_id = '67158d27f06caec7b06627a7ca0a00f2760ff6b11b4ec7cc3bca9a5afdaa23e8'
AND (
token = 'dKa3LW9MULRrTHzdT/XJ5/KykS02opc71kdiA5ThsGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)