UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1WOKKj+jZKgQdibgu9xeSDH0+ZV6HNVdL6m7yYzBoPI='
WHERE
key_id = '7d64a52c5678fc67016fe716b40a29b23a8dad8535a963a05c76d99a59ad29e3'
AND (
token = '1WOKKj+jZKgQdibgu9xeSDH0+ZV6HNVdL6m7yYzBoPI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)