UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q0TW3rDAAyFa6znSWNQNQ4aMURSoLHSjrCqEYsjALFI='
WHERE
key_id = 'fd2446fcfff234c573a6edf6a8a98af0517ac5e1e12ff597b4883a7af4258cd7'
AND (
token = 'q0TW3rDAAyFa6znSWNQNQ4aMURSoLHSjrCqEYsjALFI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)