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