UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ogA4DoAv7nI6icCaH5fv1msQyHjQBDDkAyAQ4oKNRAo='
WHERE
key_id = '3fd0411156d0510e60d4699aeca8fe200c17e1d67425c2be302a31a261109eb7'
AND (
token = 'ogA4DoAv7nI6icCaH5fv1msQyHjQBDDkAyAQ4oKNRAo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)