UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8MMiT+kFBb/iosfZhfIXxMtA4HpfmQ+TzOMawubpSsM='
WHERE
key_id = '71f118dd08762e13fe8f5da3d7b36788661c70b627012b86112ad5dae3a8dade'
AND (
token = '8MMiT+kFBb/iosfZhfIXxMtA4HpfmQ+TzOMawubpSsM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)