UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r7WO1wZX+o57ZoJjr6ZS35Cts6kjw06ixgYzDSyKUeg='
WHERE
key_id = 'e0df5b2aef1babd8877bb39dffc1e46d4a9d915dc02c2087208a4012f39b183a'
AND (
token = 'r7WO1wZX+o57ZoJjr6ZS35Cts6kjw06ixgYzDSyKUeg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)