UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8iuGJof0SFHQgwdFDMLSNG+BhQoZ4IJKFvU79+O+N/o='
WHERE
key_id = '6692dbc5adb57c2d1791c464d4734df719ee4da2f1463b3aff27849e2118e438'
AND (
token = '8iuGJof0SFHQgwdFDMLSNG+BhQoZ4IJKFvU79+O+N/o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)