UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xgW+vt97jKAzRmXyqkFmClIAnedVvb/svHpK4I6TB+U='
WHERE
key_id = 'de2a4ded39639e3b28363076f9ee8e36841208edca394e02efc180569fba4dab'
AND (
token = 'xgW+vt97jKAzRmXyqkFmClIAnedVvb/svHpK4I6TB+U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)