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