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