UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bseZrhGUxmDJen1XTzILTkzuEi4nxB7KxHTwknbEPzU='
WHERE
key_id = 'cc9f19ba5d943e84f05716a5345649383bebb0b65883b8b43f3db357dab9b516'
AND (
token = 'bseZrhGUxmDJen1XTzILTkzuEi4nxB7KxHTwknbEPzU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)