UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B0lMNztfax1osKjQHMlQLJCpSmag+POJJ1HZ2X2zTjU='
WHERE
key_id = 'a7dc42a26f8a6b6e7e45c4db765bcfbbecc576fc143c5c8157f688dee82ce777'
AND (
token = 'B0lMNztfax1osKjQHMlQLJCpSmag+POJJ1HZ2X2zTjU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)