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