UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X8FaGu8TqRL8eHIi45azE6VQvB3RZYf4n8QHa0wZ/40='
WHERE
key_id = 'a58d291c6658889c7aaab71f74729112d83d7bf38b8220e0a602f60cc9f41d76'
AND (
token = 'X8FaGu8TqRL8eHIi45azE6VQvB3RZYf4n8QHa0wZ/40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)