UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZTMbpGb0lkpuaNKiDwpj6CL2k8kT71HJty8iGGmOSW4='
WHERE
key_id = 'b4bc3a66c9db9d18fd043df48b2d29562d0fe7971cb594405f2d8edc414cb6b9'
AND (
token = 'ZTMbpGb0lkpuaNKiDwpj6CL2k8kT71HJty8iGGmOSW4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)