UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NS0bydHm6YT2NXMJuRbImJhlv2PE0cP6vs2yL0ShXmo='
WHERE
key_id = '1db5f1bec3f254067bc20faf31e2da6de0a240a6d5797dd3736cac72f68e550c'
AND (
token = 'NS0bydHm6YT2NXMJuRbImJhlv2PE0cP6vs2yL0ShXmo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)