UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'naIgZ/Qqmn3mK6zkg4jGraYyifvnztecvvAiA7IVcoY='
WHERE
key_id = 'c8e07e823b4952c66f667ae12eb2a6e9c59a5fac578267335705e2800227a116'
AND (
token = 'naIgZ/Qqmn3mK6zkg4jGraYyifvnztecvvAiA7IVcoY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)