UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hP7B0IWwEYABCMu1volSwyxz0oJ9/lp3PXOJe22iEYM='
WHERE
key_id = 'c5b3a639206fbf743a4a8156fd7b89a5abf8a6168c51c1a1d2a11c64634dcec0'
AND (
token = 'hP7B0IWwEYABCMu1volSwyxz0oJ9/lp3PXOJe22iEYM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)