UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aUbyVA2j5PObcmHUkaVsUYsTBRQozzeJvB7cg1JR5P8='
WHERE
key_id = 'b7473f46a9622fab852b720685773b04e521ca617ffd8291a6fc213f04ab2ea2'
AND (
token = 'aUbyVA2j5PObcmHUkaVsUYsTBRQozzeJvB7cg1JR5P8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)