UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'inZi9n8/NY8sTWYp5MaGLduMrZ0IFn1O9kqDSv70ghY='
WHERE
key_id = 'b9ea5c6409d07a3b21ec90d1514fd200ca176e1edf95beb85e6edf4d4438ce27'
AND (
token = 'inZi9n8/NY8sTWYp5MaGLduMrZ0IFn1O9kqDSv70ghY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)