UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HN7KyNhJhsrUQmVZLwfDuWMMz24doUzGBzhyn5OkdpY='
WHERE
key_id = '3ec7dcae2b5c989ff1169562cf29b017417b921b9dc537458d0a499b0720c55b'
AND (
token = 'HN7KyNhJhsrUQmVZLwfDuWMMz24doUzGBzhyn5OkdpY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)