UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lHzVIOa4X+veCOsPlnZeJqHUJI0Dcz0WzsRsqAD19CU='
WHERE
key_id = '5d1e9f863c5b4e9db58d840781ed4f96913b3f1d980a0088e2263efe9205ac42'
AND (
token = 'lHzVIOa4X+veCOsPlnZeJqHUJI0Dcz0WzsRsqAD19CU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)