UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0mWE8mm0RBCNvrt+1gzPs5/JkTpqQBjxml+3Uq88UVk='
WHERE
key_id = '4d2475b6fd2fb0de8cbbbf0fdbed524bb57e993a75dd7638c3d95486efc914cc'
AND (
token = '0mWE8mm0RBCNvrt+1gzPs5/JkTpqQBjxml+3Uq88UVk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)