UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oNipyjJGae2Vrp98T5dVRRqbgS0p4hl/ggbG4bdaez0='
WHERE
key_id = '6e7aa4918f229fa719255b040233b36a4100e2dcd9f2cf9002233c43f95089fa'
AND (
token = 'oNipyjJGae2Vrp98T5dVRRqbgS0p4hl/ggbG4bdaez0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)