UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cmODqis7u+9rEzXwUDzu5pLhUfTh9yoE2bTbxxm/ZkA='
WHERE
key_id = '7e7bab0a75117c68c59ad7e2435b0d1a27bb26345fe8aee93779b076020e9b35'
AND (
token = 'cmODqis7u+9rEzXwUDzu5pLhUfTh9yoE2bTbxxm/ZkA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)